
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spShippingStatusReportGetCustomerList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spShippingStatusReportGetCustomerList]
GO

	

CREATE PROCEDURE spShippingStatusReportGetCustomerList
@OfficeID int,
@Supplier int
AS


SELECT DISTINCT
	CustomerOrLocation
	
FROM
	[ShippingStatusReport] 
WHERE [PONo_Supplier] IS NOT NULL AND [PONo_Supplier] > 0
	AND OfficeID = @OfficeID
ORDER BY [PONo_Supplier]


GO

	
  